package com.atguigu.gmall.publisher.mapper;

import com.atguigu.gmall.publisher.beans.KeywordStats;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Author: Felix
 * Date: 2022/2/15
 * Desc: 关键词统计mapper接口
 */
public interface KeywordStatsMapper {
    @Select("select keyword, sum(keyword_stats_0722.ct * " +
        "multiIf(" +
        "source = 'SEARCH',10," +
        "source = 'ORDER',5," +
        "source = 'CART',2," +
        "source = 'CLICK',1,0" +
        ")) ct from  keyword_stats_0722 where  toYYYYMMDD(stt)=#{date}" +
        " group by keyword order by ct desc limit #{limit}")
    List<KeywordStats> selectKeyword(@Param("date") Integer date, @Param("limit") Integer limit);
}
